Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 111923 |
| Missing cells | 11724 |
| Missing cells (%) | 0.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 18.8 MiB |
| Average record size in memory | 176.0 B |
Variable types
| Categorical | 11 |
|---|---|
| DateTime | 6 |
| Numeric | 5 |
order_id has a high cardinality: 98115 distinct values | High cardinality |
customer_id has a high cardinality: 98115 distinct values | High cardinality |
product_id has a high cardinality: 32486 distinct values | High cardinality |
seller_id has a high cardinality: 3050 distinct values | High cardinality |
product_category_name has a high cardinality: 73 distinct values | High cardinality |
customer_unique_id has a high cardinality: 94855 distinct values | High cardinality |
customer_city has a high cardinality: 4111 distinct values | High cardinality |
mes_compra is highly correlated with ano_compra | High correlation |
ano_compra is highly correlated with mes_compra | High correlation |
mes_compra is highly correlated with ano_compra | High correlation |
ano_compra is highly correlated with mes_compra | High correlation |
ano_compra is highly correlated with ano_mes | High correlation |
ano_mes is highly correlated with ano_compra | High correlation |
mes_compra is highly correlated with ano_compra and 1 other fields | High correlation |
ano_compra is highly correlated with mes_compra and 1 other fields | High correlation |
ano_mes is highly correlated with mes_compra and 1 other fields | High correlation |
order_delivered_carrier_date has 1873 (1.7%) missing values | Missing |
order_delivered_customer_date has 3119 (2.8%) missing values | Missing |
product_category_name has 2315 (2.1%) missing values | Missing |
order_id is uniformly distributed | Uniform |
customer_id is uniformly distributed | Uniform |
customer_unique_id is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2022-09-01 17:39:51.921877 |
|---|---|
| Analysis finished | 2022-09-01 17:40:33.028876 |
| Duration | 41.11 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 98115 |
|---|---|
| Distinct (%) | 87.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 |
|---|---|
| ab14fdcfbe524636d65ee38360e22ce8 | 20 |
| 1b15974a0141d54e36626dca3fdc731a | 20 |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 |
| Other values (98110) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3581536 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 88438 ? |
|---|---|
| Unique (%) | 79.0% |
Sample
| 1st row | e481f51cbdc54678b7cc49136f2d6af7 |
|---|---|
| 2nd row | 53cdb2fc8bc7dce0b6741e2150273451 |
| 3rd row | 47770eb9100c2d0c44946d9cf07ec65d |
| 4th row | 949d5b44dbf5de918fe9c16f97b45f8a |
| 5th row | ad21c59c0840e6cb83a9ceb5573f8159 |
Common Values
| Value | Count | Frequency (%) |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| ab14fdcfbe524636d65ee38360e22ce8 | 20 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| c05d6a79e55da72ca780ce90364abed9 | 12 | < 0.1% |
| af822dacd6f5cff7376413c03a388bb7 | 12 | < 0.1% |
| Other values (98105) | 111767 |
Length
| Value | Count | Frequency (%) |
| 8272b63d03f5f79c56e9e4120aec44ef | 21 | < 0.1% |
| 1b15974a0141d54e36626dca3fdc731a | 20 | < 0.1% |
| ab14fdcfbe524636d65ee38360e22ce8 | 20 | < 0.1% |
| 428a2f660dc84138d969ccd69a0ab6d5 | 15 | < 0.1% |
| 9ef13efd6949e4573a18964dd1bbe7f5 | 15 | < 0.1% |
| 9bdc4d4c71aa1de4606060929dee888c | 14 | < 0.1% |
| 73c8ab38f07dc94389065f7eba4f297a | 14 | < 0.1% |
| 37ee401157a3a0b28c9c6d0ed8c3b24b | 13 | < 0.1% |
| 2c2a19b5703863c908512d135aa6accc | 12 | < 0.1% |
| 637617b3ffe9e2f7a2411243829226d0 | 12 | < 0.1% |
| Other values (98105) | 111767 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 225109 | 6.3% |
| e | 224538 | 6.3% |
| 6 | 224490 | 6.3% |
| 3 | 224365 | 6.3% |
| b | 224345 | 6.3% |
| 7 | 224298 | 6.3% |
| a | 224031 | 6.3% |
| 2 | 223936 | 6.3% |
| 1 | 223771 | 6.2% |
| 8 | 223741 | 6.2% |
| Other values (6) | 1338912 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2238464 | |
| Lowercase Letter | 1343072 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 225109 | |
| 6 | 224490 | |
| 3 | 224365 | |
| 7 | 224298 | |
| 2 | 223936 | |
| 1 | 223771 | |
| 8 | 223741 | |
| 9 | 223318 | |
| 0 | 223076 | |
| 5 | 222360 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 224538 | |
| b | 224345 | |
| a | 224031 | |
| c | 223680 | |
| f | 223608 | |
| d | 222870 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2238464 | |
| Latin | 1343072 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 225109 | |
| 6 | 224490 | |
| 3 | 224365 | |
| 7 | 224298 | |
| 2 | 223936 | |
| 1 | 223771 | |
| 8 | 223741 | |
| 9 | 223318 | |
| 0 | 223076 | |
| 5 | 222360 |
Latin
| Value | Count | Frequency (%) |
| e | 224538 | |
| b | 224345 | |
| a | 224031 | |
| c | 223680 | |
| f | 223608 | |
| d | 222870 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3581536 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 225109 | 6.3% |
| e | 224538 | 6.3% |
| 6 | 224490 | 6.3% |
| 3 | 224365 | 6.3% |
| b | 224345 | 6.3% |
| 7 | 224298 | 6.3% |
| a | 224031 | 6.3% |
| 2 | 223936 | 6.3% |
| 1 | 223771 | 6.2% |
| 8 | 223741 | 6.2% |
| Other values (6) | 1338912 |
| Distinct | 98115 |
|---|---|
| Distinct (%) | 87.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 |
|---|---|
| bd5d39761aa56689a265d95d8d32b8be | 20 |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 |
| 10de381f8a8d23fff822753305f71cae | 15 |
| adb32467ecc74b53576d9d13a5a55891 | 15 |
| Other values (98110) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3581536 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 88438 ? |
|---|---|
| Unique (%) | 79.0% |
Sample
| 1st row | 9ef432eb6251297304e76186b10a928d |
|---|---|
| 2nd row | b0830fb4747a6c6d20dea0b8c802d7ef |
| 3rd row | 41ce2a54c0b03bf3443c3d931a367089 |
| 4th row | f88197465ea7920adcdbec7375364d82 |
| 5th row | 8ab97904e6daea8866dbdbc4fb7aad2c |
Common Values
| Value | Count | Frequency (%) |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 | < 0.1% |
| bd5d39761aa56689a265d95d8d32b8be | 20 | < 0.1% |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 | < 0.1% |
| 10de381f8a8d23fff822753305f71cae | 15 | < 0.1% |
| adb32467ecc74b53576d9d13a5a55891 | 15 | < 0.1% |
| a7693fba2ff9583c78751f2b66ecab9d | 14 | < 0.1% |
| d5f2b3f597c7ccafbb5cac0bcc3d6024 | 14 | < 0.1% |
| 7d321bd4e8ba1caf74c4c1aabd9ae524 | 13 | < 0.1% |
| 3b54b5978e9ace64a63f90d176ffb158 | 12 | < 0.1% |
| 9eb3d566e87289dcb0acf28e1407c839 | 12 | < 0.1% |
| Other values (98105) | 111767 |
Length
| Value | Count | Frequency (%) |
| fc3d1daec319d62d49bfb5e1f83123e9 | 21 | < 0.1% |
| be1b70680b9f9694d8c70f41fa3dc92b | 20 | < 0.1% |
| bd5d39761aa56689a265d95d8d32b8be | 20 | < 0.1% |
| 10de381f8a8d23fff822753305f71cae | 15 | < 0.1% |
| adb32467ecc74b53576d9d13a5a55891 | 15 | < 0.1% |
| a7693fba2ff9583c78751f2b66ecab9d | 14 | < 0.1% |
| d5f2b3f597c7ccafbb5cac0bcc3d6024 | 14 | < 0.1% |
| 7d321bd4e8ba1caf74c4c1aabd9ae524 | 13 | < 0.1% |
| 0d93f21f3e8543a9d0d8ece01561f5b2 | 12 | < 0.1% |
| daf15f1b940cc6a72ba558f093dc00dd | 12 | < 0.1% |
| Other values (98105) | 111767 |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 224619 | 6.3% |
| 5 | 224352 | 6.3% |
| c | 224326 | 6.3% |
| 1 | 224233 | 6.3% |
| 8 | 224174 | 6.3% |
| 6 | 224111 | 6.3% |
| 2 | 223960 | 6.3% |
| 7 | 223843 | 6.2% |
| a | 223829 | 6.2% |
| 3 | 223825 | 6.2% |
| Other values (6) | 1340264 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2238036 | |
| Lowercase Letter | 1343500 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 224352 | |
| 1 | 224233 | |
| 8 | 224174 | |
| 6 | 224111 | |
| 2 | 223960 | |
| 7 | 223843 | |
| 3 | 223825 | |
| 9 | 223530 | |
| 4 | 223011 | |
| 0 | 222997 |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 224619 | |
| c | 224326 | |
| a | 223829 | |
| b | 223678 | |
| e | 223530 | |
| d | 223518 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2238036 | |
| Latin | 1343500 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 224352 | |
| 1 | 224233 | |
| 8 | 224174 | |
| 6 | 224111 | |
| 2 | 223960 | |
| 7 | 223843 | |
| 3 | 223825 | |
| 9 | 223530 | |
| 4 | 223011 | |
| 0 | 222997 |
Latin
| Value | Count | Frequency (%) |
| f | 224619 | |
| c | 224326 | |
| a | 223829 | |
| b | 223678 | |
| e | 223530 | |
| d | 223518 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3581536 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| f | 224619 | 6.3% |
| 5 | 224352 | 6.3% |
| c | 224326 | 6.3% |
| 1 | 224233 | 6.3% |
| 8 | 224174 | 6.3% |
| 6 | 224111 | 6.3% |
| 2 | 223960 | 6.3% |
| 7 | 223843 | 6.2% |
| a | 223829 | 6.2% |
| 3 | 223825 | 6.2% |
| Other values (6) | 1340264 |
order_status
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| delivered | |
|---|---|
| shipped | 1171 |
| canceled | 637 |
| unavailable | 601 |
| processing | 355 |
| Other values (3) | 348 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.984140883 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1005532 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 108811 | |
| shipped | 1171 | 1.0% |
| canceled | 637 | 0.6% |
| unavailable | 601 | 0.5% |
| processing | 355 | 0.3% |
| invoiced | 340 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| delivered | 108811 | |
| shipped | 1171 | 1.0% |
| canceled | 637 | 0.6% |
| unavailable | 601 | 0.5% |
| processing | 355 | 0.3% |
| invoiced | 340 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 330187 | |
| d | 219778 | |
| i | 111618 | 11.1% |
| l | 110650 | 11.0% |
| v | 109755 | 10.9% |
| r | 109174 | 10.9% |
| p | 2703 | 0.3% |
| a | 2448 | 0.2% |
| c | 1974 | 0.2% |
| n | 1933 | 0.2% |
| Other values (7) | 5312 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1005532 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 330187 | |
| d | 219778 | |
| i | 111618 | 11.1% |
| l | 110650 | 11.0% |
| v | 109755 | 10.9% |
| r | 109174 | 10.9% |
| p | 2703 | 0.3% |
| a | 2448 | 0.2% |
| c | 1974 | 0.2% |
| n | 1933 | 0.2% |
| Other values (7) | 5312 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1005532 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 330187 | |
| d | 219778 | |
| i | 111618 | 11.1% |
| l | 110650 | 11.0% |
| v | 109755 | 10.9% |
| r | 109174 | 10.9% |
| p | 2703 | 0.3% |
| a | 2448 | 0.2% |
| c | 1974 | 0.2% |
| n | 1933 | 0.2% |
| Other values (7) | 5312 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1005532 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 330187 | |
| d | 219778 | |
| i | 111618 | 11.1% |
| l | 110650 | 11.0% |
| v | 109755 | 10.9% |
| r | 109174 | 10.9% |
| p | 2703 | 0.3% |
| a | 2448 | 0.2% |
| c | 1974 | 0.2% |
| n | 1933 | 0.2% |
| Other values (7) | 5312 | 0.5% |
| Distinct | 592 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| Minimum | 2017-01-06 00:00:00 |
|---|---|
| Maximum | 2018-08-20 00:00:00 |
| Distinct | 591 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 115 |
| Missing (%) | 0.1% |
| Memory size | 874.5 KiB |
| Minimum | 2017-01-06 00:00:00 |
|---|---|
| Maximum | 2018-08-24 00:00:00 |
| Distinct | 509 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 1873 |
| Missing (%) | 1.7% |
| Memory size | 874.5 KiB |
| Minimum | 2017-01-09 00:00:00 |
|---|---|
| Maximum | 2018-09-11 00:00:00 |
| Distinct | 603 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 3119 |
| Missing (%) | 2.8% |
| Memory size | 874.5 KiB |
| Minimum | 2017-01-12 00:00:00 |
|---|---|
| Maximum | 2018-10-17 00:00:00 |
| Distinct | 418 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| Minimum | 2017-02-07 00:00:00 |
|---|---|
| Maximum | 2018-10-25 00:00:00 |
order_item_id
Real number (ℝ≥0)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 717 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.198019891 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 874.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7064445674 |
|---|---|
| Coefficient of variation (CV) | 0.5896768265 |
| Kurtosis | 104.2594651 |
| Mean | 1.198019891 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.601320234 |
| Sum | 133227 |
| Variance | 0.4990639268 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 97398 | |
| 2 | 9677 | 8.6% |
| 3 | 2261 | 2.0% |
| 4 | 952 | 0.9% |
| 5 | 453 | 0.4% |
| 6 | 252 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 66 | 0.1% |
| (Missing) | 717 | 0.6% |
| Value | Count | Frequency (%) |
| 1 | 97398 | |
| 2 | 9677 | 8.6% |
| 3 | 2261 | 2.0% |
| 4 | 952 | 0.9% |
| 5 | 453 | 0.4% |
| 6 | 252 | 0.2% |
| 7 | 58 | 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 7 | |
| 13 | 8 | |
| 12 | 13 |
| Distinct | 32486 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 717 |
| Missing (%) | 0.6% |
| Memory size | 874.5 KiB |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 |
|---|---|
| 99a4788cb24856965c36a24e339b6058 | 488 |
| 422879e10f46682990de24d770e7f83d | 484 |
| 389d119b48cf3043d311335e499d9c6b | 392 |
| 368c6c730842d78016ad823897a372db | 387 |
| Other values (32481) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3558592 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 17864 ? |
|---|---|
| Unique (%) | 16.1% |
Sample
| 1st row | 87285b34884572647811a353c7ac498a |
|---|---|
| 2nd row | 595fac2a385ac33a80bd5114aec74eb8 |
| 3rd row | aa4383b373c6aca5d8797843e5594415 |
| 4th row | d0b61bfb1de832b15ba9d266ca96e5b0 |
| 5th row | 65266b2da20d04dbe00c5c2d3bb7859e |
Common Values
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 488 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 484 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 392 | 0.4% |
| 368c6c730842d78016ad823897a372db | 387 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 370 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 342 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 281 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 274 | 0.2% |
| Other values (32476) | 107338 | |
| (Missing) | 717 | 0.6% |
Length
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 527 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 488 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 484 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 392 | 0.4% |
| 368c6c730842d78016ad823897a372db | 387 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 370 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 342 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 281 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 274 | 0.2% |
| Other values (32476) | 107338 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 228870 | 6.4% |
| 9 | 226536 | 6.4% |
| e | 224669 | 6.3% |
| 7 | 224186 | 6.3% |
| 8 | 223825 | 6.3% |
| 4 | 223416 | 6.3% |
| a | 222982 | 6.3% |
| c | 222118 | 6.2% |
| 0 | 222106 | 6.2% |
| 2 | 222081 | 6.2% |
| Other values (6) | 1317803 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2233846 | |
| Lowercase Letter | 1324746 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 228870 | |
| 9 | 226536 | |
| 7 | 224186 | |
| 8 | 223825 | |
| 4 | 223416 | |
| 0 | 222106 | |
| 2 | 222081 | |
| 5 | 221504 | |
| 6 | 221108 | |
| 1 | 220214 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 224669 | |
| a | 222982 | |
| c | 222118 | |
| b | 220702 | |
| d | 218679 | |
| f | 215596 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2233846 | |
| Latin | 1324746 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 228870 | |
| 9 | 226536 | |
| 7 | 224186 | |
| 8 | 223825 | |
| 4 | 223416 | |
| 0 | 222106 | |
| 2 | 222081 | |
| 5 | 221504 | |
| 6 | 221108 | |
| 1 | 220214 |
Latin
| Value | Count | Frequency (%) |
| e | 224669 | |
| a | 222982 | |
| c | 222118 | |
| b | 220702 | |
| d | 218679 | |
| f | 215596 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3558592 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 228870 | 6.4% |
| 9 | 226536 | 6.4% |
| e | 224669 | 6.3% |
| 7 | 224186 | 6.3% |
| 8 | 223825 | 6.3% |
| 4 | 223416 | 6.3% |
| a | 222982 | 6.3% |
| c | 222118 | 6.2% |
| 0 | 222106 | 6.2% |
| 2 | 222081 | 6.2% |
| Other values (6) | 1317803 |
| Distinct | 3050 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 717 |
| Missing (%) | 0.6% |
| Memory size | 874.5 KiB |
| 6560211a19b47992c3666cc44a7e94c0 | 2000 |
|---|---|
| 4a3ca9315b744ce9f8e9374361493884 | 1982 |
| 1f50f920176fa81dab994f9023523100 | 1923 |
| cc419e0650a3c5ba77189a1882b7556a | 1766 |
| da8622b14eb17ae2831f4ac5b9dab84a | 1534 |
| Other values (3045) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3558592 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 497 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
|---|---|
| 2nd row | 289cdb325fb7e7f891c38608bf9e0962 |
| 3rd row | 4869f7a5dfa277a7dca6462dcf3b52b2 |
| 4th row | 66922902710d126a0e7d26b0e3805106 |
| 5th row | 2c9e548be18521d1c43cde1c582c6de8 |
Common Values
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2000 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1982 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1923 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1766 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1534 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1483 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1422 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1364 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1200 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1170 | 1.0% |
| Other values (3040) | 95362 |
Length
| Value | Count | Frequency (%) |
| 6560211a19b47992c3666cc44a7e94c0 | 2000 | 1.8% |
| 4a3ca9315b744ce9f8e9374361493884 | 1982 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 1923 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1766 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1534 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1483 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1422 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1364 | 1.2% |
| ea8482cd71df3c1969d7b9473ff13abc | 1200 | 1.1% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1170 | 1.1% |
| Other values (3040) | 95362 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 241277 | 6.8% |
| c | 234639 | 6.6% |
| 4 | 233185 | 6.6% |
| 6 | 229166 | 6.4% |
| 0 | 228229 | 6.4% |
| a | 226825 | 6.4% |
| 3 | 226197 | 6.4% |
| b | 226194 | 6.4% |
| 9 | 220774 | 6.2% |
| 2 | 220068 | 6.2% |
| Other values (6) | 1272038 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2250830 | |
| Lowercase Letter | 1307762 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 241277 | |
| 4 | 233185 | |
| 6 | 229166 | |
| 0 | 228229 | |
| 3 | 226197 | |
| 9 | 220774 | |
| 2 | 220068 | |
| 5 | 217495 | |
| 8 | 217424 | |
| 7 | 217015 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 234639 | |
| a | 226825 | |
| b | 226194 | |
| e | 209539 | |
| f | 206299 | |
| d | 204266 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2250830 | |
| Latin | 1307762 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 241277 | |
| 4 | 233185 | |
| 6 | 229166 | |
| 0 | 228229 | |
| 3 | 226197 | |
| 9 | 220774 | |
| 2 | 220068 | |
| 5 | 217495 | |
| 8 | 217424 | |
| 7 | 217015 |
Latin
| Value | Count | Frequency (%) |
| c | 234639 | |
| a | 226825 | |
| b | 226194 | |
| e | 209539 | |
| f | 206299 | |
| d | 204266 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3558592 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 241277 | 6.8% |
| c | 234639 | 6.6% |
| 4 | 233185 | 6.6% |
| 6 | 229166 | 6.4% |
| 0 | 228229 | 6.4% |
| a | 226825 | 6.4% |
| 3 | 226197 | 6.4% |
| b | 226194 | 6.4% |
| 9 | 220774 | 6.2% |
| 2 | 220068 | 6.2% |
| Other values (6) | 1272038 |
| Distinct | 528 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 717 |
| Missing (%) | 0.6% |
| Memory size | 874.5 KiB |
| Minimum | 2017-01-10 00:00:00 |
|---|---|
| Maximum | 2020-04-09 00:00:00 |
price
Real number (ℝ≥0)
| Distinct | 5914 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 717 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.8459546 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 874.5 KiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17.37 |
| Q1 | 39.9 |
| median | 74.99 |
| Q3 | 134.99 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95.09 |
Descriptive statistics
| Standard deviation | 183.9417558 |
|---|---|
| Coefficient of variation (CV) | 1.522117611 |
| Kurtosis | 121.1401143 |
| Mean | 120.8459546 |
| Median Absolute Deviation (MAD) | 42.09 |
| Skewness | 7.933903095 |
| Sum | 13438795.23 |
| Variance | 33834.56953 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2446 | 2.2% |
| 69.9 | 1975 | 1.8% |
| 49.9 | 1919 | 1.7% |
| 89.9 | 1536 | 1.4% |
| 99.9 | 1418 | 1.3% |
| 39.9 | 1318 | 1.2% |
| 29.9 | 1301 | 1.2% |
| 79.9 | 1196 | 1.1% |
| 19.9 | 1181 | 1.1% |
| 29.99 | 1162 | 1.0% |
| Other values (5904) | 95754 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.29 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| 3.54 | 1 | < 0.1% |
| 3.85 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6729 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 |
freight_value
Real number (ℝ≥0)
| Distinct | 6977 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 717 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.03207893 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 381 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 874.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.28 |
| Q3 | 21.18 |
| 95-th percentile | 45.2 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.1 |
Descriptive statistics
| Standard deviation | 15.8479909 |
|---|---|
| Coefficient of variation (CV) | 0.7911306139 |
| Kurtosis | 59.74854478 |
| Mean | 20.03207893 |
| Median Absolute Deviation (MAD) | 3.59 |
| Skewness | 5.64120452 |
| Sum | 2227687.37 |
| Variance | 251.1588157 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3707 | 3.3% |
| 7.78 | 2260 | 2.0% |
| 14.1 | 1875 | 1.7% |
| 11.85 | 1845 | 1.6% |
| 18.23 | 1561 | 1.4% |
| 7.39 | 1476 | 1.3% |
| 16.11 | 1151 | 1.0% |
| 15.23 | 1005 | 0.9% |
| 8.72 | 885 | 0.8% |
| 16.79 | 872 | 0.8% |
| Other values (6967) | 94569 |
| Value | Count | Frequency (%) |
| 0 | 381 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 4 | < 0.1% |
| 0.06 | 11 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2315 |
| Missing (%) | 2.1% |
| Memory size | 874.5 KiB |
| cama_mesa_banho | |
|---|---|
| beleza_saude | |
| esporte_lazer | |
| moveis_decoracao | |
| informatica_acessorios | |
| Other values (68) |
Length
| Max length | 46 |
|---|---|
| Median length | 32 |
| Mean length | 14.8608587 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1628869 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | utilidades_domesticas |
|---|---|
| 2nd row | perfumaria |
| 3rd row | automotivo |
| 4th row | pet_shop |
| 5th row | papelaria |
Common Values
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11016 | 9.8% |
| beleza_saude | 9487 | 8.5% |
| esporte_lazer | 8541 | 7.6% |
| moveis_decoracao | 8223 | 7.3% |
| informatica_acessorios | 7752 | 6.9% |
| utilidades_domesticas | 6840 | 6.1% |
| relogios_presentes | 5932 | 5.3% |
| telefonia | 4501 | 4.0% |
| ferramentas_jardim | 4325 | 3.9% |
| automotivo | 4174 | 3.7% |
| Other values (63) | 38817 |
Length
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11016 | 10.1% |
| beleza_saude | 9487 | 8.7% |
| esporte_lazer | 8541 | 7.8% |
| moveis_decoracao | 8223 | 7.5% |
| informatica_acessorios | 7752 | 7.1% |
| utilidades_domesticas | 6840 | 6.2% |
| relogios_presentes | 5932 | 5.4% |
| telefonia | 4501 | 4.1% |
| ferramentas_jardim | 4325 | 3.9% |
| automotivo | 4174 | 3.8% |
| Other values (63) | 38817 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 198340 | |
| a | 195308 | |
| s | 162363 | |
| o | 161280 | |
| i | 108297 | 6.6% |
| r | 105230 | 6.5% |
| _ | 103261 | 6.3% |
| t | 78568 | 4.8% |
| c | 77136 | 4.7% |
| m | 73290 | 4.5% |
| Other values (18) | 365796 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1525341 | |
| Connector Punctuation | 103261 | 6.3% |
| Decimal Number | 267 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 198340 | |
| a | 195308 | |
| s | 162363 | |
| o | 161280 | |
| i | 108297 | 7.1% |
| r | 105230 | 6.9% |
| t | 78568 | 5.2% |
| c | 77136 | 5.1% |
| m | 73290 | 4.8% |
| n | 55685 | 3.7% |
| Other values (16) | 309844 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 103261 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 267 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1525341 | |
| Common | 103528 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 198340 | |
| a | 195308 | |
| s | 162363 | |
| o | 161280 | |
| i | 108297 | 7.1% |
| r | 105230 | 6.9% |
| t | 78568 | 5.2% |
| c | 77136 | 5.1% |
| m | 73290 | 4.8% |
| n | 55685 | 3.7% |
| Other values (16) | 309844 |
Common
| Value | Count | Frequency (%) |
| _ | 103261 | |
| 2 | 267 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1628869 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 198340 | |
| a | 195308 | |
| s | 162363 | |
| o | 161280 | |
| i | 108297 | 6.6% |
| r | 105230 | 6.5% |
| _ | 103261 | 6.3% |
| t | 78568 | 4.8% |
| c | 77136 | 4.7% |
| m | 73290 | 4.5% |
| Other values (18) | 365796 |
| Distinct | 94855 |
|---|---|
| Distinct (%) | 84.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| c8460e4251689ba205045f3ea17884a1 | 24 |
|---|---|
| 4546caea018ad8c692964e3382debd19 | 21 |
| c402f431464c72e27330a67f7b94d4fb | 20 |
| 698e1cf81d01a3d389d96145f7fa6df8 | 20 |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 |
| Other values (94850) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3581536 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 83088 ? |
|---|---|
| Unique (%) | 74.2% |
Sample
| 1st row | 7c396fd4830fd04220f754e42b4e5bff |
|---|---|
| 2nd row | af07308b275d755c9edb36a90c618231 |
| 3rd row | 3a653a41f6f9fc3d2a113cf8398680e8 |
| 4th row | 7c142cf63193a1473d2e66489a9ae977 |
| 5th row | 72632f0f9dd73dfee390c9b22eb56dd6 |
Common Values
| Value | Count | Frequency (%) |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 4546caea018ad8c692964e3382debd19 | 21 | < 0.1% |
| c402f431464c72e27330a67f7b94d4fb | 20 | < 0.1% |
| 698e1cf81d01a3d389d96145f7fa6df8 | 20 | < 0.1% |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 | < 0.1% |
| 8d50f5eadf50201ccdcedfb9e2ac8455 | 17 | < 0.1% |
| 11f97da02237a49c8e783dfda6f50e8e | 15 | < 0.1% |
| eae0a83d752b1dd32697e0e7b4221656 | 15 | < 0.1% |
| 3e43e6105506432c953e165fb2acf44c | 14 | < 0.1% |
| f7ea4eef770a388bd5b225acfc546604 | 14 | < 0.1% |
| Other values (94845) | 111745 |
Length
| Value | Count | Frequency (%) |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 4546caea018ad8c692964e3382debd19 | 21 | < 0.1% |
| c402f431464c72e27330a67f7b94d4fb | 20 | < 0.1% |
| 698e1cf81d01a3d389d96145f7fa6df8 | 20 | < 0.1% |
| 0f5ac8d5c31de21d2f25e24be15bbffb | 18 | < 0.1% |
| 8d50f5eadf50201ccdcedfb9e2ac8455 | 17 | < 0.1% |
| 11f97da02237a49c8e783dfda6f50e8e | 15 | < 0.1% |
| eae0a83d752b1dd32697e0e7b4221656 | 15 | < 0.1% |
| 31e412b9fb766b6794724ed17a41dfa6 | 14 | < 0.1% |
| 3e43e6105506432c953e165fb2acf44c | 14 | < 0.1% |
| Other values (94845) | 111745 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 224540 | 6.3% |
| 1 | 224529 | 6.3% |
| e | 224189 | 6.3% |
| 8 | 224183 | 6.3% |
| a | 224044 | 6.3% |
| 9 | 224023 | 6.3% |
| d | 223980 | 6.3% |
| 5 | 223931 | 6.3% |
| 3 | 223876 | 6.3% |
| 0 | 223850 | 6.3% |
| Other values (6) | 1340391 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2239049 | |
| Lowercase Letter | 1342487 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 224540 | |
| 1 | 224529 | |
| 8 | 224183 | |
| 9 | 224023 | |
| 5 | 223931 | |
| 3 | 223876 | |
| 0 | 223850 | |
| 2 | 223780 | |
| 7 | 223383 | |
| 4 | 222954 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 224189 | |
| a | 224044 | |
| d | 223980 | |
| b | 223778 | |
| f | 223373 | |
| c | 223123 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2239049 | |
| Latin | 1342487 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 224540 | |
| 1 | 224529 | |
| 8 | 224183 | |
| 9 | 224023 | |
| 5 | 223931 | |
| 3 | 223876 | |
| 0 | 223850 | |
| 2 | 223780 | |
| 7 | 223383 | |
| 4 | 222954 |
Latin
| Value | Count | Frequency (%) |
| e | 224189 | |
| a | 224044 | |
| d | 223980 | |
| b | 223778 | |
| f | 223373 | |
| c | 223123 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3581536 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 224540 | 6.3% |
| 1 | 224529 | 6.3% |
| e | 224189 | 6.3% |
| 8 | 224183 | 6.3% |
| a | 224044 | 6.3% |
| 9 | 224023 | 6.3% |
| d | 223980 | 6.3% |
| 5 | 223931 | 6.3% |
| 3 | 223876 | 6.3% |
| 0 | 223850 | 6.3% |
| Other values (6) | 1340391 |
| Distinct | 4111 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| sao paulo | |
|---|---|
| rio de janeiro | 7783 |
| belo horizonte | 3117 |
| brasilia | 2380 |
| curitiba | 1703 |
| Other values (4106) |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.33843803 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1157109 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1060 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | sao paulo |
|---|---|
| 2nd row | barreiras |
| 3rd row | vianopolis |
| 4th row | sao goncalo do amarante |
| 5th row | santo andre |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 17590 | 15.7% |
| rio de janeiro | 7783 | 7.0% |
| belo horizonte | 3117 | 2.8% |
| brasilia | 2380 | 2.1% |
| curitiba | 1703 | 1.5% |
| campinas | 1633 | 1.5% |
| porto alegre | 1601 | 1.4% |
| salvador | 1415 | 1.3% |
| guarulhos | 1313 | 1.2% |
| sao bernardo do campo | 1047 | 0.9% |
| Other values (4101) | 72341 |
Length
| Value | Count | Frequency (%) |
| sao | 23726 | 12.1% |
| paulo | 17670 | 9.0% |
| de | 10904 | 5.6% |
| rio | 9376 | 4.8% |
| janeiro | 7783 | 4.0% |
| do | 4835 | 2.5% |
| belo | 3186 | 1.6% |
| horizonte | 3145 | 1.6% |
| brasilia | 2390 | 1.2% |
| porto | 1910 | 1.0% |
| Other values (3279) | 111242 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 190734 | |
| o | 142753 | |
| i | 88671 | 7.7% |
| r | 86013 | 7.4% |
| 84244 | 7.3% | |
| e | 75242 | 6.5% |
| s | 70677 | 6.1% |
| n | 51406 | 4.4% |
| u | 50594 | 4.4% |
| l | 50440 | 4.4% |
| Other values (21) | 266335 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1072352 | |
| Space Separator | 84244 | 7.3% |
| Dash Punctuation | 260 | < 0.1% |
| Other Punctuation | 251 | < 0.1% |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 190734 | |
| o | 142753 | |
| i | 88671 | 8.3% |
| r | 86013 | 8.0% |
| e | 75242 | 7.0% |
| s | 70677 | 6.6% |
| n | 51406 | 4.8% |
| u | 50594 | 4.7% |
| l | 50440 | 4.7% |
| p | 41966 | 3.9% |
| Other values (16) | 223856 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 84244 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 260 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 251 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1072352 | |
| Common | 84757 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 190734 | |
| o | 142753 | |
| i | 88671 | 8.3% |
| r | 86013 | 8.0% |
| e | 75242 | 7.0% |
| s | 70677 | 6.6% |
| n | 51406 | 4.8% |
| u | 50594 | 4.7% |
| l | 50440 | 4.7% |
| p | 41966 | 3.9% |
| Other values (16) | 223856 |
Common
| Value | Count | Frequency (%) |
| 84244 | ||
| - | 260 | 0.3% |
| ' | 251 | 0.3% |
| 1 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1157109 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 190734 | |
| o | 142753 | |
| i | 88671 | 7.7% |
| r | 86013 | 7.4% |
| 84244 | 7.3% | |
| e | 75242 | 6.5% |
| s | 70677 | 6.1% |
| n | 51406 | 4.4% |
| u | 50594 | 4.4% |
| l | 50440 | 4.4% |
| Other values (21) | 266335 |
customer_state
Categorical
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 223846 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | BA |
| 3rd row | GO |
| 4th row | RN |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 46972 | |
| RJ | 14509 | 13.0% |
| MG | 13068 | 11.7% |
| RS | 6211 | 5.5% |
| PR | 5685 | 5.1% |
| SC | 4161 | 3.7% |
| BA | 3811 | 3.4% |
| DF | 2394 | 2.1% |
| GO | 2329 | 2.1% |
| ES | 2250 | 2.0% |
| Other values (17) | 10533 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 46972 | |
| rj | 14509 | 13.0% |
| mg | 13068 | 11.7% |
| rs | 6211 | 5.5% |
| pr | 5685 | 5.1% |
| sc | 4161 | 3.7% |
| ba | 3811 | 3.4% |
| df | 2394 | 2.1% |
| go | 2329 | 2.1% |
| es | 2250 | 2.0% |
| Other values (17) | 10533 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 60805 | |
| P | 56759 | |
| R | 27314 | |
| M | 15925 | 7.1% |
| G | 15397 | 6.9% |
| J | 14509 | 6.5% |
| A | 6492 | 2.9% |
| E | 5911 | 2.6% |
| C | 5728 | 2.6% |
| B | 4413 | 2.0% |
| Other values (7) | 10593 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 223846 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 60805 | |
| P | 56759 | |
| R | 27314 | |
| M | 15925 | 7.1% |
| G | 15397 | 6.9% |
| J | 14509 | 6.5% |
| A | 6492 | 2.9% |
| E | 5911 | 2.6% |
| C | 5728 | 2.6% |
| B | 4413 | 2.0% |
| Other values (7) | 10593 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 223846 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 60805 | |
| P | 56759 | |
| R | 27314 | |
| M | 15925 | 7.1% |
| G | 15397 | 6.9% |
| J | 14509 | 6.5% |
| A | 6492 | 2.9% |
| E | 5911 | 2.6% |
| C | 5728 | 2.6% |
| B | 4413 | 2.0% |
| Other values (7) | 10593 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 223846 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 60805 | |
| P | 56759 | |
| R | 27314 | |
| M | 15925 | 7.1% |
| G | 15397 | 6.9% |
| J | 14509 | 6.5% |
| A | 6492 | 2.9% |
| E | 5911 | 2.6% |
| C | 5728 | 2.6% |
| B | 4413 | 2.0% |
| Other values (7) | 10593 | 4.7% |
dia_compra
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.51285259 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 874.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 15 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.667442147 |
|---|---|
| Coefficient of variation (CV) | 0.5587265204 |
| Kurtosis | -1.171315268 |
| Mean | 15.51285259 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.02641766669 |
| Sum | 1736245 |
| Variance | 75.12455336 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 4302 | 3.8% |
| 16 | 4089 | 3.7% |
| 15 | 3983 | 3.6% |
| 6 | 3908 | 3.5% |
| 18 | 3901 | 3.5% |
| 19 | 3881 | 3.5% |
| 5 | 3871 | 3.5% |
| 14 | 3831 | 3.4% |
| 4 | 3815 | 3.4% |
| 7 | 3761 | 3.4% |
| Other values (21) | 72581 |
| Value | Count | Frequency (%) |
| 1 | 3503 | |
| 2 | 3655 | |
| 3 | 3678 | |
| 4 | 3815 | |
| 5 | 3871 | |
| 6 | 3908 | |
| 7 | 3761 | |
| 8 | 3727 | |
| 9 | 3671 | |
| 10 | 3533 |
| Value | Count | Frequency (%) |
| 31 | 1925 | |
| 30 | 2877 | |
| 29 | 2917 | |
| 28 | 3365 | |
| 27 | 3570 | |
| 26 | 3720 | |
| 25 | 3706 | |
| 24 | 4302 | |
| 23 | 3462 | |
| 22 | 3488 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.000670104 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 874.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.241051271 |
|---|---|
| Coefficient of variation (CV) | 0.5401148896 |
| Kurtosis | -0.9756885162 |
| Mean | 6.000670104 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.2285576007 |
| Sum | 671613 |
| Variance | 10.50441334 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 12121 | |
| 7 | 11687 | |
| 3 | 11281 | |
| 8 | 11193 | |
| 6 | 10696 | |
| 4 | 10677 | |
| 2 | 9704 | |
| 1 | 9191 | |
| 11 | 8758 | |
| 12 | 6357 | |
| Other values (2) | 10258 |
| Value | Count | Frequency (%) |
| 1 | 9191 | |
| 2 | 9704 | |
| 3 | 11281 | |
| 4 | 10677 | |
| 5 | 12121 | |
| 6 | 10696 | |
| 7 | 11687 | |
| 8 | 11193 | |
| 9 | 4873 | |
| 10 | 5385 |
| Value | Count | Frequency (%) |
| 12 | 6357 | |
| 11 | 8758 | |
| 10 | 5385 | |
| 9 | 4873 | |
| 8 | 11193 | |
| 7 | 11687 | |
| 6 | 10696 | |
| 5 | 12121 | |
| 4 | 10677 | |
| 3 | 11281 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| 2018 | |
|---|---|
| 2017 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 447692 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2018 |
| 3rd row | 2018 |
| 4th row | 2017 |
| 5th row | 2018 |
Common Values
| Value | Count | Frequency (%) |
| 2018 | 60569 | |
| 2017 | 51354 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2018 | 60569 | |
| 2017 | 51354 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 111923 | |
| 0 | 111923 | |
| 1 | 111923 | |
| 8 | 60569 | |
| 7 | 51354 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 447692 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 111923 | |
| 0 | 111923 | |
| 1 | 111923 | |
| 8 | 60569 | |
| 7 | 51354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 447692 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 111923 | |
| 0 | 111923 | |
| 1 | 111923 | |
| 8 | 60569 | |
| 7 | 51354 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 447692 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 111923 | |
| 0 | 111923 | |
| 1 | 111923 | |
| 8 | 60569 | |
| 7 | 51354 |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 874.5 KiB |
| 2017-11 | |
|---|---|
| 2018-01 | |
| 2018-03 | |
| 2018-04 | |
| 2018-05 | |
| Other values (15) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 783461 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017-10 |
|---|---|
| 2nd row | 2018-07 |
| 3rd row | 2018-08 |
| 4th row | 2017-11 |
| 5th row | 2018-02 |
Common Values
| Value | Count | Frequency (%) |
| 2017-11 | 8758 | 7.8% |
| 2018-01 | 8257 | 7.4% |
| 2018-03 | 8240 | 7.4% |
| 2018-04 | 7980 | 7.1% |
| 2018-05 | 7945 | 7.1% |
| 2018-02 | 7706 | 6.9% |
| 2018-07 | 7111 | 6.4% |
| 2018-06 | 7085 | 6.3% |
| 2017-12 | 6357 | 5.7% |
| 2018-08 | 6245 | 5.6% |
| Other values (10) | 36239 |
Length
| Value | Count | Frequency (%) |
| 2017-11 | 8758 | 7.8% |
| 2018-01 | 8257 | 7.4% |
| 2018-03 | 8240 | 7.4% |
| 2018-04 | 7980 | 7.1% |
| 2018-05 | 7945 | 7.1% |
| 2018-02 | 7706 | 6.9% |
| 2018-07 | 7111 | 6.4% |
| 2018-06 | 7085 | 6.3% |
| 2017-12 | 6357 | 5.7% |
| 2018-08 | 6245 | 5.6% |
| Other values (10) | 36239 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 208731 | |
| 1 | 150372 | |
| 2 | 127984 | |
| - | 111923 | |
| 8 | 71762 | 9.2% |
| 7 | 63041 | 8.0% |
| 5 | 12121 | 1.5% |
| 3 | 11281 | 1.4% |
| 6 | 10696 | 1.4% |
| 4 | 10677 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 671538 | |
| Dash Punctuation | 111923 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 208731 | |
| 1 | 150372 | |
| 2 | 127984 | |
| 8 | 71762 | 10.7% |
| 7 | 63041 | 9.4% |
| 5 | 12121 | 1.8% |
| 3 | 11281 | 1.7% |
| 6 | 10696 | 1.6% |
| 4 | 10677 | 1.6% |
| 9 | 4873 | 0.7% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 111923 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 783461 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 208731 | |
| 1 | 150372 | |
| 2 | 127984 | |
| - | 111923 | |
| 8 | 71762 | 9.2% |
| 7 | 63041 | 8.0% |
| 5 | 12121 | 1.5% |
| 3 | 11281 | 1.4% |
| 6 | 10696 | 1.4% |
| 4 | 10677 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 783461 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 208731 | |
| 1 | 150372 | |
| 2 | 127984 | |
| - | 111923 | |
| 8 | 71762 | 9.2% |
| 7 | 63041 | 8.0% |
| 5 | 12121 | 1.5% |
| 3 | 11281 | 1.4% |
| 6 | 10696 | 1.4% |
| 4 | 10677 | 1.4% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | product_category_name | customer_unique_id | customer_city | customer_state | dia_compra | mes_compra | ano_compra | ano_mes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 | 2017-10-02 | 2017-10-04 | 2017-10-10 | 2017-10-18 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 | 29.99 | 8.72 | utilidades_domesticas | 7c396fd4830fd04220f754e42b4e5bff | sao paulo | SP | 2 | 10 | 2017 | 2017-10 |
| 1 | 53cdb2fc8bc7dce0b6741e2150273451 | b0830fb4747a6c6d20dea0b8c802d7ef | delivered | 2018-07-24 | 2018-07-26 | 2018-07-26 | 2018-08-07 | 2018-08-13 | 1.0 | 595fac2a385ac33a80bd5114aec74eb8 | 289cdb325fb7e7f891c38608bf9e0962 | 2018-07-30 | 118.70 | 22.76 | perfumaria | af07308b275d755c9edb36a90c618231 | barreiras | BA | 24 | 7 | 2018 | 2018-07 |
| 2 | 47770eb9100c2d0c44946d9cf07ec65d | 41ce2a54c0b03bf3443c3d931a367089 | delivered | 2018-08-08 | 2018-08-08 | 2018-08-08 | 2018-08-17 | 2018-09-04 | 1.0 | aa4383b373c6aca5d8797843e5594415 | 4869f7a5dfa277a7dca6462dcf3b52b2 | 2018-08-13 | 159.90 | 19.22 | automotivo | 3a653a41f6f9fc3d2a113cf8398680e8 | vianopolis | GO | 8 | 8 | 2018 | 2018-08 |
| 3 | 949d5b44dbf5de918fe9c16f97b45f8a | f88197465ea7920adcdbec7375364d82 | delivered | 2017-11-18 | 2017-11-18 | 2017-11-22 | 2017-12-02 | 2017-12-15 | 1.0 | d0b61bfb1de832b15ba9d266ca96e5b0 | 66922902710d126a0e7d26b0e3805106 | 2017-11-23 | 45.00 | 27.20 | pet_shop | 7c142cf63193a1473d2e66489a9ae977 | sao goncalo do amarante | RN | 18 | 11 | 2017 | 2017-11 |
| 4 | ad21c59c0840e6cb83a9ceb5573f8159 | 8ab97904e6daea8866dbdbc4fb7aad2c | delivered | 2018-02-13 | 2018-02-13 | 2018-02-14 | 2018-02-16 | 2018-02-26 | 1.0 | 65266b2da20d04dbe00c5c2d3bb7859e | 2c9e548be18521d1c43cde1c582c6de8 | 2018-02-19 | 19.90 | 8.72 | papelaria | 72632f0f9dd73dfee390c9b22eb56dd6 | santo andre | SP | 13 | 2 | 2018 | 2018-02 |
| 5 | a4591c265e18cb1dcee52889e2d8acc3 | 503740e9ca751ccdda7ba28e9ab8f608 | delivered | 2017-07-09 | 2017-07-09 | 2017-07-11 | 2017-07-26 | 2017-08-01 | 1.0 | 060cb19345d90064d1015407193c233d | 8581055ce74af1daba164fdbd55a40de | 2017-07-13 | 147.90 | 27.36 | automotivo | 80bb27c7c16e8f973207a5086ab329e2 | congonhinhas | PR | 9 | 7 | 2017 | 2017-07 |
| 6 | 136cce7faa42fdb2cefd53fdc79a6098 | ed0271e0b7da060a393796590e7b737a | invoiced | 2017-04-11 | 2017-04-13 | NaT | NaT | 2017-05-09 | 1.0 | a1804276d9941ac0733cfd409f5206eb | dc8798cbf453b7e0f98745e396cc5616 | 2017-04-19 | 49.90 | 16.05 | NaN | 36edbb3fb164b1f16485364b6fb04c73 | santa rosa | RS | 11 | 4 | 2017 | 2017-04 |
| 7 | 6514b8ad8028c9f2cc2374ded245783f | 9bdf08b4b3b52b5526ff42d37d47f222 | delivered | 2017-05-16 | 2017-05-16 | 2017-05-22 | 2017-05-26 | 2017-06-07 | 1.0 | 4520766ec412348b8d4caa5e8a18c464 | 16090f2ca825584b5a147ab24aa30c86 | 2017-05-22 | 59.99 | 15.17 | automotivo | 932afa1e708222e5821dac9cd5db4cae | nilopolis | RJ | 16 | 5 | 2017 | 2017-05 |
| 8 | 76c6e866289321a7c93b82b54852dc33 | f54a9f0e6b351c431402b8461ea51999 | delivered | 2017-01-23 | 2017-01-25 | 2017-01-26 | 2017-02-02 | 2017-03-06 | 1.0 | ac1789e492dcd698c5c10b97a671243a | 63b9ae557efed31d1f7687917d248a8d | 2017-01-27 | 19.90 | 16.05 | moveis_decoracao | 39382392765b6dc74812866ee5ee92a7 | faxinalzinho | RS | 23 | 1 | 2017 | 2017-01 |
| 9 | e69bfb5eb88e0ed6a785585b27e16dbf | 31ad1d1b63eb9962463f764d4e6e0c9d | delivered | 2017-07-29 | 2017-07-29 | 2017-08-10 | 2017-08-16 | 2017-08-23 | 1.0 | 9a78fb9862b10749a117f7fc3c31f051 | 7c67e1448b00f6e969d365cea6b010ab | 2017-08-11 | 149.99 | 19.77 | moveis_escritorio | 299905e3934e9e181bfb2e164dd4b4f8 | sorocaba | SP | 29 | 7 | 2017 | 2017-07 |
Last rows
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | product_category_name | customer_unique_id | customer_city | customer_state | dia_compra | mes_compra | ano_compra | ano_mes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111913 | 9115830be804184b91f5c00f6f49f92d | da2124f134f5dfbce9d06f29bdb6c308 | delivered | 2017-10-04 | 2017-10-04 | 2017-10-05 | 2017-10-20 | 2017-11-07 | 1.0 | c982dbea53b864f4d27c1d36f14b6053 | 1caf283236cd69af44cbc09a0a1e7d32 | 2017-10-10 | 42.11 | 0.80 | brinquedos | c716cf2b5b86fb24257cffe9e7969df8 | cuiaba | MT | 4 | 10 | 2017 | 2017-10 |
| 111914 | 9115830be804184b91f5c00f6f49f92d | da2124f134f5dfbce9d06f29bdb6c308 | delivered | 2017-10-04 | 2017-10-04 | 2017-10-05 | 2017-10-20 | 2017-11-07 | 2.0 | 49d2e2460386273b195e7e59b43587c3 | 1caf283236cd69af44cbc09a0a1e7d32 | 2017-10-10 | 26.90 | 36.98 | brinquedos | c716cf2b5b86fb24257cffe9e7969df8 | cuiaba | MT | 4 | 10 | 2017 | 2017-10 |
| 111915 | aa04ef5214580b06b10e2a378300db44 | f01a6bfcc730456317e4081fe0c9940e | delivered | 2017-01-27 | 2017-01-27 | 2017-01-30 | 2017-02-07 | 2017-03-17 | 1.0 | 9fc063fd34fed29ccc57b7f8e8d03388 | ccc4bbb5f32a6ab2b7066a4130f114e3 | 2017-02-03 | 370.00 | 19.43 | beleza_saude | e03dbdf5e56c96b106d8115ac336f47f | divinopolis | MG | 27 | 1 | 2017 | 2017-01 |
| 111916 | 880675dff2150932f1601e1c07eadeeb | 47cd45a6ac7b9fb16537df2ccffeb5ac | delivered | 2017-02-23 | 2017-02-23 | 2017-03-01 | 2017-03-06 | 2017-03-22 | 1.0 | ea73128566d1b082e5101ce46f8107c7 | 391fc6631aebcf3004804e51b40bcf1e | 2017-02-27 | 139.90 | 16.09 | moveis_decoracao | 831ce3f1bacbd424fc4e38fbd4d66d29 | sao paulo | SP | 23 | 2 | 2017 | 2017-02 |
| 111917 | 9c5dedf39a927c1b2549525ed64a053c | 39bd1228ee8140590ac3aca26f2dfe00 | delivered | 2017-03-09 | 2017-03-09 | 2017-03-10 | 2017-03-17 | 2017-03-28 | 1.0 | ac35486adb7b02598c182c2ff2e05254 | e24fc9fcd865784fb25705606fe3dfe7 | 2017-03-15 | 72.00 | 13.08 | beleza_saude | 6359f309b166b0196dbf7ad2ac62bb5a | sao jose dos campos | SP | 9 | 3 | 2017 | 2017-03 |
| 111918 | 63943bddc261676b46f01ca7ac2f7bd8 | 1fca14ff2861355f6e5f14306ff977a7 | delivered | 2018-02-06 | 2018-02-06 | 2018-02-07 | 2018-02-28 | 2018-03-02 | 1.0 | f1d4ce8c6dd66c47bbaa8c6781c2a923 | 1f9ab4708f3056ede07124aad39a2554 | 2018-02-12 | 174.90 | 20.10 | bebes | da62f9e57a76d978d02ab5362c509660 | praia grande | SP | 6 | 2 | 2018 | 2018-02 |
| 111919 | 83c1379a015df1e13d02aae0204711ab | 1aa71eb042121263aafbe80c1b562c9c | delivered | 2017-08-27 | 2017-08-27 | 2017-08-28 | 2017-09-21 | 2017-09-27 | 1.0 | b80910977a37536adeddd63663f916ad | d50d79cb34e38265a8649c383dcffd48 | 2017-09-05 | 205.99 | 65.02 | eletrodomesticos_2 | 737520a9aad80b3fbbdad19b66b37b30 | nova vicosa | BA | 27 | 8 | 2017 | 2017-08 |
| 111920 | 11c177c8e97725db2631073c19f07b62 | b331b74b18dc79bcdf6532d51e1637c1 | delivered | 2018-01-08 | 2018-01-08 | 2018-01-12 | 2018-01-25 | 2018-02-15 | 1.0 | d1c427060a0f73f6b889a5c7c61f2ac4 | a1043bafd471dff536d0c462352beb48 | 2018-01-12 | 179.99 | 40.59 | informatica_acessorios | 5097a5312c8b157bb7be58ae360ef43c | japuiba | RJ | 8 | 1 | 2018 | 2018-01 |
| 111921 | 11c177c8e97725db2631073c19f07b62 | b331b74b18dc79bcdf6532d51e1637c1 | delivered | 2018-01-08 | 2018-01-08 | 2018-01-12 | 2018-01-25 | 2018-02-15 | 2.0 | d1c427060a0f73f6b889a5c7c61f2ac4 | a1043bafd471dff536d0c462352beb48 | 2018-01-12 | 179.99 | 40.59 | informatica_acessorios | 5097a5312c8b157bb7be58ae360ef43c | japuiba | RJ | 8 | 1 | 2018 | 2018-01 |
| 111922 | 66dea50a8b16d9b4dee7af250b4be1a5 | edb027a75a1449115f6b43211ae02a24 | delivered | 2018-03-08 | 2018-03-09 | 2018-03-09 | 2018-03-16 | 2018-04-03 | 1.0 | 006619bbed68b000c8ba3f8725d5409e | ececbfcff9804a2d6b40f589df8eef2b | 2018-03-15 | 68.50 | 18.36 | beleza_saude | 60350aa974b26ff12caad89e55993bd6 | lapa | PR | 8 | 3 | 2018 | 2018-03 |